Release 10.1A: OpenEdge Getting Started:
Database Essentials


Deactivating indexes

Indexes that you seldom use can impair performance by causing unnecessary overhead. If you do not want to delete a seldom-used index, then deactivate it. Deactivating an index eliminates the processing overhead associated with the index, but does not free up its disk space. For information on how to deactivate indexes, see OpenEdge Data Management: Database Administration . To learn how to do this using SQL, see OpenEdge Data Management: SQL Reference .


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095